package com.grom.service;

import java.util.List;

import com.grom.dao.DatabaseDao;
import com.grom.po.BrandVisitHistory;
import com.holder.DBContextHolder;
import com.holder.DBUTil;

public interface BrandHistoryService {
	BrandHistoryService instance = new BrandHistoryService() {

		public List<BrandVisitHistory> getHistoryByBrandId(String brandId) {
			DBContextHolder.setContextConnection(DatabaseDao.getConnection());
			String sql = "select * from brandvisithistory where brandid ='" + brandId + "'";
			return DBUTil.getResult(sql, BrandVisitHistory.class);
		}

	};

	List<BrandVisitHistory> getHistoryByBrandId(String brandId);
}
